package com.mrd.gtimp.business.repository;

import com.mrd.gtimp.business.entity.CompanyQp;
import com.mrd.spring.repository.BaseRepository;

import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * <p>
 * application name: gtimp
 * <p>
 * copyright: Copyright@2012 明睿达科技有限公司
 */
/**
 * @author yangyl
 */
public interface CompanyQpDao extends BaseRepository<CompanyQp,String> {
    /**
     * 查询地址、联系电话、传真
     * @param code 编码
     */
    @Query("select t.COMPANY_ADDRESS, t.COMPANY_PHONE, t.COMPANY_FAX from com.mrd.gtimp.business.entity.CompanyQp t where t.companyCode = ?")
    List<Object[]> queryCompanyQpAddressAndPhoneAndFax(String code);
}
